home *** CD-ROM | disk | FTP | other *** search
/ Delphi Magazine Collection 2001 / Delphi Magazine Collection 20001 (2001).iso / DISKS / Issue52 / Ado / ADOTransPro1U1.pas < prev   
Encoding:
Pascal/Delphi Source File  |  1999-11-03  |  1.7 KB  |  66 lines
  1. unit ADOTransPro1U1;
  2.  
  3. interface
  4.  
  5. uses
  6.   Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  7.   StdCtrls, Grids, DBGrids, Db, DBCtrls, ExtCtrls, ADODB, OLEDB;
  8.  
  9. type
  10.   TForm1 = class(TForm)
  11.     ADOConnection1: TADOConnection;
  12.     ADOTable1: TADOTable;
  13.     Panel1: TPanel;
  14.     DBNavigator1: TDBNavigator;
  15.     DataSource1: TDataSource;
  16.     DBGrid1: TDBGrid;
  17.     btnBeginTrans: TButton;
  18.     btnCommitTrans: TButton;
  19.     btnRollbackTrans: TButton;
  20.     Memo1: TMemo;
  21.     Button1: TButton;
  22.     procedure btnBeginTransClick(Sender: TObject);
  23.     procedure btnCommitTransClick(Sender: TObject);
  24.     procedure btnRollbackTransClick(Sender: TObject);
  25.     procedure Button1Click(Sender: TObject);
  26.   private
  27.     { Private declarations }
  28.   public
  29.     { Public declarations }
  30.   end;
  31.  
  32. var
  33.   Form1: TForm1;
  34.  
  35. implementation
  36.  
  37. {$R *.DFM}
  38.  
  39. procedure TForm1.btnBeginTransClick(Sender: TObject);
  40. begin
  41.   ADOConnection1.BeginTrans;
  42. end;
  43.  
  44. procedure TForm1.btnCommitTransClick(Sender: TObject);
  45. begin
  46.   ADOConnection1.CommitTrans;
  47. end;
  48.  
  49. procedure TForm1.btnRollbackTransClick(Sender: TObject);
  50. begin
  51.   ADOConnection1.RollbackTrans;
  52. end;
  53.  
  54. procedure TForm1.Button1Click(Sender: TObject);
  55. begin
  56.   case ADOConnection1.Properties['Transaction DDL'].Value of
  57.   DBPROPVAL_TC_NONE      : ShowMessage('Transactions are not supported');
  58.   DBPROPVAL_TC_DML       : ShowMessage('Transactions can contain DML. DDL causes an exception');
  59.   DBPROPVAL_TC_DDL_COMMIT: ShowMessage('Transactions can contain DML. DDL causes transactions to commit');
  60.   DBPROPVAL_TC_DDL_IGNORE: ShowMessage('Transactions can contain DML. DDL is ignored');
  61.   DBPROPVAL_TC_ALL       : ShowMessage('Transactions can contain DML and DDL');
  62.   end;
  63. end;
  64.  
  65. end.
  66.